package cj.web.yc.dao;
/*
 *  
 *  
*/
import java.util.List;
import java.util.Map;

import net.paoding.rose.jade.annotation.DAO;
import net.paoding.rose.jade.annotation.SQL;

/**
 * 
 * @author 
 *
 */
@DAO
public interface CategoryDAO{
	
    @SQL("SELECT id,pid,name,value FROM category WHERE id=:1 AND pid=:2 AND deleteFlag =1 ORDER BY orderNo ")
    List<Map> queryByIdandPid(int id,int pid);
    
    @SQL("SELECT id,pid,name,value FROM category WHERE pid=:1 AND deleteFlag =1 ORDER BY orderNo ")
    List<Map> queryByPid(int pid);
}